import pandas as pd
writer = pd.ExcelWriter('data.xlsx')
df = pd.read_excel('长沙省厅专业及普适型地灾监测项目（2+20个点）-设备在线情况表 (2).xlsx')
df = df[['省级编号','监测点名称']]
print(df)
x = []
index_list = []
for t,s in df.iterrows():
 if (s[0] in x):
     index_list.append(t)
 else:
     x.append(s[0])
df.drop(df.index[index_list], inplace=True)
df.to_excel(writer, sheet_name='proj_name', index=False)
writer.save()
